using System.Data;
using System.Data.SqlClient;

namespace OneDayModel.DBRepository.MSSQL
{
    public class SqlServerFetcher : IDbFetcher
    {

        public IDataReader GetRolesReader(IDbConnection dbConnection)
        {
            SqlCommand command = new SqlCommand("SELECT id, roles_id, name, is_public FROM roles ORDER BY roles_id, id");
            command.Connection = (SqlConnection) dbConnection;
            return command.ExecuteReader();
        }
    }
}